Uploading a file

Before you upload a file, you must specify the type of file that you are uploading. This enables the system to correctly read the data in the file.

Important: If the uploaded file contains information for a beneficiary that already exists, the details in the file will overwrite the existing beneficiary details.

To upload a file

  1. In the toolbar, click Upload.
    The Upload Center opens.

    Upload Center
  2. From the Template dropdown list, choose the type of file that you are uploading. If you select the wrong template type for the file you are uploading, the file status will be Incompatible and the information in the file will not be processed.
    The following templates are available by default. If you have any customized templates, they will also appear in the dropdown list.
    • Default Payment Import File—The file contains payment information only. The beneficiaries must already exist in our system.
    • Cambridge Full Payment File—The file contains payment information as well as information to create or update the beneficiaries who will receive those payments.
      Note: If you are a Named Account user and want to settle from your Multi-Currency Account, in the Full Payment file, enter C in column ANSettlement Method.
    • Cambridge Beneficiary Import File—The file contains information to create or update beneficiaries. The file cannot include any payment details.
      Note: If the beneficiary data includes an email address, the Send Pay Tracker feature is automatically enabled for that beneficiary. When a payment to that beneficiary is released, a notification is sent to the specified address.
  3. Locate the file you want to upload, and then drag the file into the file drop area.
    Alternatively, you can click in the Drop zone, and, in the window that opens, locate the file you want to upload. Then, either double-click on the filename, or select it and click Open.

    Upload Center

    Note: The file cannot include PO Box or any variation of PO Box in the Beneficiary address fields if the Beneficiary country is Australia, Canada, or Mexico .

    If your account configuration requires you to authenticate via Multi-Factor Authentication when creating or editing beneficiaries, you will be prompted to select one of the authentication methods you set up. If the authentication is successful, the upload continues. For more information on Multi-Factor Authentication, see Multi-Factor Authentication.
    Note: This does not apply to importing bills from Sage Intacct.

    The uploaded file is listed in the grid at the bottom of the page.

    Note: If an uploaded file contains any special characters, they will be stripped out.